﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Local" targetNamespace="http://tempuri.org/Local.xsd" xmlns:mstns="http://tempuri.org/Local.xsd" xmlns="http://tempuri.org/Local.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ERP_MOVILConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ERP_MOVILConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MMSA.Entities.Properties.Settings.GlobalReference.Default.ERP_MOVILConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RUT_LOCALTableAdapter" GeneratorDataComponentClassName="RUT_LOCALTableAdapter" Name="RUT_LOCAL" UserDataComponentName="RUT_LOCALTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ERP_MOVILConnectionString (Settings)" DbObjectName="ERP_MOVIL.dbo.RUT_LOCAL" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[RUT_LOCAL] WHERE (([loc_id] = @Original_loc_id) AND ((@IsNull_loc_nombre = 1 AND [loc_nombre] IS NULL) OR ([loc_nombre] = @Original_loc_nombre)) AND ((@IsNull_loc_direccion = 1 AND [loc_direccion] IS NULL) OR ([loc_direccion] = @Original_loc_direccion)) AND ((@IsNull_loc_referencia = 1 AND [loc_referencia] IS NULL) OR ([loc_referencia] = @Original_loc_referencia)) AND ((@IsNull_loc_pais = 1 AND [loc_pais] IS NULL) OR ([loc_pais] = @Original_loc_pais)) AND ((@IsNull_loc_provincia = 1 AND [loc_provincia] IS NULL) OR ([loc_provincia] = @Original_loc_provincia)) AND ((@IsNull_loc_ciudad = 1 AND [loc_ciudad] IS NULL) OR ([loc_ciudad] = @Original_loc_ciudad)) AND ((@IsNull_loc_foto = 1 AND [loc_foto] IS NULL) OR ([loc_foto] = @Original_loc_foto)) AND ((@IsNull_loc_ruc = 1 AND [loc_ruc] IS NULL) OR ([loc_ruc] = @Original_loc_ruc)) AND ((@IsNull_loc_telefono1 = 1 AND [loc_telefono1] IS NULL) OR ([loc_telefono1] = @Original_loc_telefono1)) AND ((@IsNull_loc_telefono2 = 1 AND [loc_telefono2] IS NULL) OR ([loc_telefono2] = @Original_loc_telefono2)) AND ((@p3 = 1 AND [loc_tipo/canal] IS NULL) OR ([loc_tipo/canal] = @p2)) AND ((@IsNull_loc_estado = 1 AND [loc_estado] IS NULL) OR ([loc_estado] = @Original_loc_estado)) AND ((@IsNull_loc_longitud = 1 AND [loc_longitud] IS NULL) OR ([loc_longitud] = @Original_loc_longitud)) AND ((@IsNull_loc_latitud = 1 AND [loc_latitud] IS NULL) OR ([loc_latitud] = @Original_loc_latitud)) AND ((@IsNull_loc_per_id = 1 AND [loc_per_id] IS NULL) OR ([loc_per_id] = @Original_loc_per_id)) AND ((@IsNull_loc_fre_id = 1 AND [loc_fre_id] IS NULL) OR ([loc_fre_id] = @Original_loc_fre_id)) AND ((@IsNull_loc_id_usuario = 1 AND [loc_id_usuario] IS NULL) OR ([loc_id_usuario] = @Original_loc_id_usuario)) AND ((@IsNull_loc_id_orden = 1 AND [loc_id_orden] IS NULL) OR ([loc_id_orden] = @Original_loc_id_orden)) AND ((@IsNull_loc_id_cod1 = 1 AND [loc_id_cod1] IS NULL) OR ([loc_id_cod1] = @Original_loc_id_cod1)) AND ((@IsNull_loc_id_cod2 = 1 AND [loc_id_cod2] IS NULL) OR ([loc_id_cod2] = @Original_loc_id_cod2)) AND ((@IsNull_loc_id_cod3 = 1 AND [loc_id_cod3] IS NULL) OR ([loc_id_cod3] = @Original_loc_id_cod3)) AND ((@IsNull_loc_id_cod4 = 1 AND [loc_id_cod4] IS NULL) OR ([loc_id_cod4] = @Original_loc_id_cod4)) AND ((@IsNull_frecuencia = 1 AND [frecuencia] IS NULL) OR ([frecuencia] = @Original_frecuencia)) AND ((@IsNull_loc_cupo = 1 AND [loc_cupo] IS NULL) OR ([loc_cupo] = @Original_loc_cupo)) AND ((@IsNull_loc_plazo = 1 AND [loc_plazo] IS NULL) OR ([loc_plazo] = @Original_loc_plazo)) AND ([lst_id] = @Original_lst_id) AND ((@IsNull_loc_nuevo = 1 AND [loc_nuevo] IS NULL) OR ([loc_nuevo] = @Original_loc_nuevo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_nombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_direccion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_direccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_direccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_referencia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_referencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_referencia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_referencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_pais" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_pais" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_pais" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_pais" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_provincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_provincia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_provincia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_ciudad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_ciudad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_ciudad" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_ciudad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_foto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_foto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_foto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_foto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_ruc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_ruc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_ruc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_ruc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_telefono1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_telefono1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_telefono1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_telefono1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_telefono2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_telefono2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_telefono2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_telefono2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_tipo/canal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_tipo/canal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_estado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_loc_estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="loc_estado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_longitud" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_longitud" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_loc_longitud" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="loc_longitud" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_latitud" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_latitud" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_loc_latitud" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="loc_latitud" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_per_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_per_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_per_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_per_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_fre_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_fre_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_fre_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_fre_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id_usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_usuario" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_id_usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_usuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id_orden" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_orden" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_id_orden" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_orden" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id_cod1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_cod1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_id_cod1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id_cod2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_cod2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_id_cod2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id_cod3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_cod3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_id_cod3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id_cod4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_cod4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_id_cod4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_frecuencia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="frecuencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_frecuencia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="frecuencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_cupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_cupo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_loc_cupo" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="loc_cupo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_plazo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_plazo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_plazo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_plazo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lst_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lst_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_nuevo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_nuevo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_loc_nuevo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="loc_nuevo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[RUT_LOCAL] ([loc_nombre], [loc_direccion], [loc_referencia], [loc_pais], [loc_provincia], [loc_ciudad], [loc_foto], [loc_ruc], [loc_telefono1], [loc_telefono2], [loc_tipo/canal], [loc_estado], [loc_longitud], [loc_latitud], [loc_per_id], [loc_fre_id], [loc_id_usuario], [loc_id_orden], [loc_id_cod1], [loc_id_cod2], [loc_id_cod3], [loc_id_cod4], [frecuencia], [loc_cupo], [loc_plazo], [lst_id], [loc_nuevo]) VALUES (@loc_nombre, @loc_direccion, @loc_referencia, @loc_pais, @loc_provincia, @loc_ciudad, @loc_foto, @loc_ruc, @loc_telefono1, @loc_telefono2, @p1, @loc_estado, @loc_longitud, @loc_latitud, @loc_per_id, @loc_fre_id, @loc_id_usuario, @loc_id_orden, @loc_id_cod1, @loc_id_cod2, @loc_id_cod3, @loc_id_cod4, @frecuencia, @loc_cupo, @loc_plazo, @lst_id, @loc_nuevo);
SELECT loc_id, loc_nombre, loc_direccion, loc_referencia, loc_pais, loc_provincia, loc_ciudad, loc_foto, loc_ruc, loc_telefono1, loc_telefono2, [loc_tipo/canal], loc_estado, loc_longitud, loc_latitud, loc_per_id, loc_fre_id, loc_id_usuario, loc_id_orden, loc_id_cod1, loc_id_cod2, loc_id_cod3, loc_id_cod4, frecuencia, loc_cupo, loc_plazo, lst_id, loc_nuevo FROM RUT_LOCAL WHERE (loc_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_referencia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_referencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_pais" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_pais" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_provincia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_ciudad" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_ciudad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_foto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_foto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_ruc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_ruc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_telefono1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_telefono1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_telefono2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_telefono2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_tipo/canal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@loc_estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="loc_estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@loc_longitud" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="loc_longitud" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@loc_latitud" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="loc_latitud" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loc_per_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_per_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loc_fre_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_fre_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loc_id_usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_usuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loc_id_orden" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_orden" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_id_cod1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_id_cod2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_id_cod3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_id_cod4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@frecuencia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="frecuencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@loc_cupo" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="loc_cupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loc_plazo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_plazo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lst_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lst_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@loc_nuevo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="loc_nuevo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT loc_id, loc_nombre, loc_direccion, loc_referencia, loc_pais, loc_provincia, loc_ciudad, loc_foto, loc_ruc, loc_telefono1, loc_telefono2, [loc_tipo/canal], loc_estado, loc_longitud, loc_latitud, loc_per_id, loc_fre_id, loc_id_usuario, loc_id_orden, loc_id_cod1, loc_id_cod2, loc_id_cod3, loc_id_cod4, frecuencia, loc_cupo, loc_plazo, lst_id, loc_nuevo FROM dbo.RUT_LOCAL</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[RUT_LOCAL] SET [loc_nombre] = @loc_nombre, [loc_direccion] = @loc_direccion, [loc_referencia] = @loc_referencia, [loc_pais] = @loc_pais, [loc_provincia] = @loc_provincia, [loc_ciudad] = @loc_ciudad, [loc_foto] = @loc_foto, [loc_ruc] = @loc_ruc, [loc_telefono1] = @loc_telefono1, [loc_telefono2] = @loc_telefono2, [loc_tipo/canal] = @p1, [loc_estado] = @loc_estado, [loc_longitud] = @loc_longitud, [loc_latitud] = @loc_latitud, [loc_per_id] = @loc_per_id, [loc_fre_id] = @loc_fre_id, [loc_id_usuario] = @loc_id_usuario, [loc_id_orden] = @loc_id_orden, [loc_id_cod1] = @loc_id_cod1, [loc_id_cod2] = @loc_id_cod2, [loc_id_cod3] = @loc_id_cod3, [loc_id_cod4] = @loc_id_cod4, [frecuencia] = @frecuencia, [loc_cupo] = @loc_cupo, [loc_plazo] = @loc_plazo, [lst_id] = @lst_id, [loc_nuevo] = @loc_nuevo WHERE (([loc_id] = @Original_loc_id) AND ((@IsNull_loc_nombre = 1 AND [loc_nombre] IS NULL) OR ([loc_nombre] = @Original_loc_nombre)) AND ((@IsNull_loc_direccion = 1 AND [loc_direccion] IS NULL) OR ([loc_direccion] = @Original_loc_direccion)) AND ((@IsNull_loc_referencia = 1 AND [loc_referencia] IS NULL) OR ([loc_referencia] = @Original_loc_referencia)) AND ((@IsNull_loc_pais = 1 AND [loc_pais] IS NULL) OR ([loc_pais] = @Original_loc_pais)) AND ((@IsNull_loc_provincia = 1 AND [loc_provincia] IS NULL) OR ([loc_provincia] = @Original_loc_provincia)) AND ((@IsNull_loc_ciudad = 1 AND [loc_ciudad] IS NULL) OR ([loc_ciudad] = @Original_loc_ciudad)) AND ((@IsNull_loc_foto = 1 AND [loc_foto] IS NULL) OR ([loc_foto] = @Original_loc_foto)) AND ((@IsNull_loc_ruc = 1 AND [loc_ruc] IS NULL) OR ([loc_ruc] = @Original_loc_ruc)) AND ((@IsNull_loc_telefono1 = 1 AND [loc_telefono1] IS NULL) OR ([loc_telefono1] = @Original_loc_telefono1)) AND ((@IsNull_loc_telefono2 = 1 AND [loc_telefono2] IS NULL) OR ([loc_telefono2] = @Original_loc_telefono2)) AND ((@p3 = 1 AND [loc_tipo/canal] IS NULL) OR ([loc_tipo/canal] = @p2)) AND ((@IsNull_loc_estado = 1 AND [loc_estado] IS NULL) OR ([loc_estado] = @Original_loc_estado)) AND ((@IsNull_loc_longitud = 1 AND [loc_longitud] IS NULL) OR ([loc_longitud] = @Original_loc_longitud)) AND ((@IsNull_loc_latitud = 1 AND [loc_latitud] IS NULL) OR ([loc_latitud] = @Original_loc_latitud)) AND ((@IsNull_loc_per_id = 1 AND [loc_per_id] IS NULL) OR ([loc_per_id] = @Original_loc_per_id)) AND ((@IsNull_loc_fre_id = 1 AND [loc_fre_id] IS NULL) OR ([loc_fre_id] = @Original_loc_fre_id)) AND ((@IsNull_loc_id_usuario = 1 AND [loc_id_usuario] IS NULL) OR ([loc_id_usuario] = @Original_loc_id_usuario)) AND ((@IsNull_loc_id_orden = 1 AND [loc_id_orden] IS NULL) OR ([loc_id_orden] = @Original_loc_id_orden)) AND ((@IsNull_loc_id_cod1 = 1 AND [loc_id_cod1] IS NULL) OR ([loc_id_cod1] = @Original_loc_id_cod1)) AND ((@IsNull_loc_id_cod2 = 1 AND [loc_id_cod2] IS NULL) OR ([loc_id_cod2] = @Original_loc_id_cod2)) AND ((@IsNull_loc_id_cod3 = 1 AND [loc_id_cod3] IS NULL) OR ([loc_id_cod3] = @Original_loc_id_cod3)) AND ((@IsNull_loc_id_cod4 = 1 AND [loc_id_cod4] IS NULL) OR ([loc_id_cod4] = @Original_loc_id_cod4)) AND ((@IsNull_frecuencia = 1 AND [frecuencia] IS NULL) OR ([frecuencia] = @Original_frecuencia)) AND ((@IsNull_loc_cupo = 1 AND [loc_cupo] IS NULL) OR ([loc_cupo] = @Original_loc_cupo)) AND ((@IsNull_loc_plazo = 1 AND [loc_plazo] IS NULL) OR ([loc_plazo] = @Original_loc_plazo)) AND ([lst_id] = @Original_lst_id) AND ((@IsNull_loc_nuevo = 1 AND [loc_nuevo] IS NULL) OR ([loc_nuevo] = @Original_loc_nuevo)));
SELECT loc_id, loc_nombre, loc_direccion, loc_referencia, loc_pais, loc_provincia, loc_ciudad, loc_foto, loc_ruc, loc_telefono1, loc_telefono2, [loc_tipo/canal], loc_estado, loc_longitud, loc_latitud, loc_per_id, loc_fre_id, loc_id_usuario, loc_id_orden, loc_id_cod1, loc_id_cod2, loc_id_cod3, loc_id_cod4, frecuencia, loc_cupo, loc_plazo, lst_id, loc_nuevo FROM RUT_LOCAL WHERE (loc_id = @loc_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_referencia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_referencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_pais" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_pais" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_provincia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_ciudad" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_ciudad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_foto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_foto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_ruc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_ruc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_telefono1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_telefono1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_telefono2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_telefono2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_tipo/canal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@loc_estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="loc_estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@loc_longitud" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="loc_longitud" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@loc_latitud" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="loc_latitud" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loc_per_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_per_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loc_fre_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_fre_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loc_id_usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_usuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loc_id_orden" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_orden" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_id_cod1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_id_cod2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_id_cod3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loc_id_cod4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@frecuencia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="frecuencia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@loc_cupo" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="loc_cupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loc_plazo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_plazo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lst_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lst_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@loc_nuevo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="loc_nuevo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_nombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_direccion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_direccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_direccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_referencia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_referencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_referencia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_referencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_pais" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_pais" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_pais" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_pais" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_provincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_provincia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_provincia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_provincia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_ciudad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_ciudad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_ciudad" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_ciudad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_foto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_foto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_foto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_foto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_ruc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_ruc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_ruc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_ruc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_telefono1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_telefono1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_telefono1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_telefono1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_telefono2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_telefono2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_telefono2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_telefono2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_tipo/canal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_tipo/canal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_estado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_loc_estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="loc_estado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_longitud" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_longitud" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_loc_longitud" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="loc_longitud" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_latitud" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_latitud" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_loc_latitud" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="loc_latitud" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_per_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_per_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_per_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_per_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_fre_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_fre_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_fre_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_fre_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id_usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_usuario" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_id_usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_usuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id_orden" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_orden" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_id_orden" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_orden" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id_cod1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_cod1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_id_cod1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id_cod2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_cod2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_id_cod2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id_cod3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_cod3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_id_cod3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id_cod4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id_cod4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loc_id_cod4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loc_id_cod4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_frecuencia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="frecuencia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_frecuencia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="frecuencia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_cupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_cupo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_loc_cupo" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="loc_cupo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_plazo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_plazo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_plazo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_plazo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lst_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="lst_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_nuevo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_nuevo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_loc_nuevo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="loc_nuevo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="loc_id" ColumnName="loc_id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@loc_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="loc_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="loc_id" DataSetColumn="loc_id" />
              <Mapping SourceColumn="loc_nombre" DataSetColumn="loc_nombre" />
              <Mapping SourceColumn="loc_direccion" DataSetColumn="loc_direccion" />
              <Mapping SourceColumn="loc_referencia" DataSetColumn="loc_referencia" />
              <Mapping SourceColumn="loc_pais" DataSetColumn="loc_pais" />
              <Mapping SourceColumn="loc_provincia" DataSetColumn="loc_provincia" />
              <Mapping SourceColumn="loc_ciudad" DataSetColumn="loc_ciudad" />
              <Mapping SourceColumn="loc_foto" DataSetColumn="loc_foto" />
              <Mapping SourceColumn="loc_ruc" DataSetColumn="loc_ruc" />
              <Mapping SourceColumn="loc_telefono1" DataSetColumn="loc_telefono1" />
              <Mapping SourceColumn="loc_telefono2" DataSetColumn="loc_telefono2" />
              <Mapping SourceColumn="loc_tipo/canal" DataSetColumn="loc_tipo/canal" />
              <Mapping SourceColumn="loc_estado" DataSetColumn="loc_estado" />
              <Mapping SourceColumn="loc_longitud" DataSetColumn="loc_longitud" />
              <Mapping SourceColumn="loc_latitud" DataSetColumn="loc_latitud" />
              <Mapping SourceColumn="loc_per_id" DataSetColumn="loc_per_id" />
              <Mapping SourceColumn="loc_fre_id" DataSetColumn="loc_fre_id" />
              <Mapping SourceColumn="loc_id_usuario" DataSetColumn="loc_id_usuario" />
              <Mapping SourceColumn="loc_id_orden" DataSetColumn="loc_id_orden" />
              <Mapping SourceColumn="loc_id_cod1" DataSetColumn="loc_id_cod1" />
              <Mapping SourceColumn="loc_id_cod2" DataSetColumn="loc_id_cod2" />
              <Mapping SourceColumn="loc_id_cod3" DataSetColumn="loc_id_cod3" />
              <Mapping SourceColumn="loc_id_cod4" DataSetColumn="loc_id_cod4" />
              <Mapping SourceColumn="frecuencia" DataSetColumn="frecuencia" />
              <Mapping SourceColumn="loc_cupo" DataSetColumn="loc_cupo" />
              <Mapping SourceColumn="loc_plazo" DataSetColumn="loc_plazo" />
              <Mapping SourceColumn="lst_id" DataSetColumn="lst_id" />
              <Mapping SourceColumn="loc_nuevo" DataSetColumn="loc_nuevo" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Local" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="Local" msprop:Generator_UserDSName="Local">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="RUT_LOCAL" msprop:Generator_TableClassName="RUT_LOCALDataTable" msprop:Generator_TableVarName="tableRUT_LOCAL" msprop:Generator_TablePropName="RUT_LOCAL" msprop:Generator_RowDeletingName="RUT_LOCALRowDeleting" msprop:Generator_RowChangingName="RUT_LOCALRowChanging" msprop:Generator_RowEvHandlerName="RUT_LOCALRowChangeEventHandler" msprop:Generator_RowDeletedName="RUT_LOCALRowDeleted" msprop:Generator_UserTableName="RUT_LOCAL" msprop:Generator_RowChangedName="RUT_LOCALRowChanged" msprop:Generator_RowEvArgName="RUT_LOCALRowChangeEvent" msprop:Generator_RowClassName="RUT_LOCALRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="loc_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnloc_id" msprop:Generator_ColumnPropNameInRow="loc_id" msprop:Generator_ColumnPropNameInTable="loc_idColumn" msprop:Generator_UserColumnName="loc_id" type="xs:int" />
              <xs:element name="loc_nombre" msprop:Generator_ColumnVarNameInTable="columnloc_nombre" msprop:Generator_ColumnPropNameInRow="loc_nombre" msprop:Generator_ColumnPropNameInTable="loc_nombreColumn" msprop:Generator_UserColumnName="loc_nombre" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_direccion" msprop:Generator_ColumnVarNameInTable="columnloc_direccion" msprop:Generator_ColumnPropNameInRow="loc_direccion" msprop:Generator_ColumnPropNameInTable="loc_direccionColumn" msprop:Generator_UserColumnName="loc_direccion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_referencia" msprop:Generator_ColumnVarNameInTable="columnloc_referencia" msprop:Generator_ColumnPropNameInRow="loc_referencia" msprop:Generator_ColumnPropNameInTable="loc_referenciaColumn" msprop:Generator_UserColumnName="loc_referencia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_pais" msprop:Generator_ColumnVarNameInTable="columnloc_pais" msprop:Generator_ColumnPropNameInRow="loc_pais" msprop:Generator_ColumnPropNameInTable="loc_paisColumn" msprop:Generator_UserColumnName="loc_pais" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_provincia" msprop:Generator_ColumnVarNameInTable="columnloc_provincia" msprop:Generator_ColumnPropNameInRow="loc_provincia" msprop:Generator_ColumnPropNameInTable="loc_provinciaColumn" msprop:Generator_UserColumnName="loc_provincia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_ciudad" msprop:Generator_ColumnVarNameInTable="columnloc_ciudad" msprop:Generator_ColumnPropNameInRow="loc_ciudad" msprop:Generator_ColumnPropNameInTable="loc_ciudadColumn" msprop:Generator_UserColumnName="loc_ciudad" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_foto" msprop:Generator_ColumnVarNameInTable="columnloc_foto" msprop:Generator_ColumnPropNameInRow="loc_foto" msprop:Generator_ColumnPropNameInTable="loc_fotoColumn" msprop:Generator_UserColumnName="loc_foto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_ruc" msprop:Generator_ColumnVarNameInTable="columnloc_ruc" msprop:Generator_ColumnPropNameInRow="loc_ruc" msprop:Generator_ColumnPropNameInTable="loc_rucColumn" msprop:Generator_UserColumnName="loc_ruc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_telefono1" msprop:Generator_ColumnVarNameInTable="columnloc_telefono1" msprop:Generator_ColumnPropNameInRow="loc_telefono1" msprop:Generator_ColumnPropNameInTable="loc_telefono1Column" msprop:Generator_UserColumnName="loc_telefono1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_telefono2" msprop:Generator_ColumnVarNameInTable="columnloc_telefono2" msprop:Generator_ColumnPropNameInRow="loc_telefono2" msprop:Generator_ColumnPropNameInTable="loc_telefono2Column" msprop:Generator_UserColumnName="loc_telefono2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_tipo_x002F_canal" msprop:Generator_ColumnVarNameInTable="_columnloc_tipo_canal" msprop:Generator_ColumnPropNameInRow="_loc_tipo_canal" msprop:Generator_ColumnPropNameInTable="_loc_tipo_canalColumn" msprop:Generator_UserColumnName="loc_tipo/canal" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_estado" msprop:Generator_ColumnVarNameInTable="columnloc_estado" msprop:Generator_ColumnPropNameInRow="loc_estado" msprop:Generator_ColumnPropNameInTable="loc_estadoColumn" msprop:Generator_UserColumnName="loc_estado" type="xs:boolean" minOccurs="0" />
              <xs:element name="loc_longitud" msprop:Generator_ColumnVarNameInTable="columnloc_longitud" msprop:Generator_ColumnPropNameInRow="loc_longitud" msprop:Generator_ColumnPropNameInTable="loc_longitudColumn" msprop:Generator_UserColumnName="loc_longitud" type="xs:double" minOccurs="0" />
              <xs:element name="loc_latitud" msprop:Generator_ColumnVarNameInTable="columnloc_latitud" msprop:Generator_ColumnPropNameInRow="loc_latitud" msprop:Generator_ColumnPropNameInTable="loc_latitudColumn" msprop:Generator_UserColumnName="loc_latitud" type="xs:double" minOccurs="0" />
              <xs:element name="loc_per_id" msprop:Generator_ColumnVarNameInTable="columnloc_per_id" msprop:Generator_ColumnPropNameInRow="loc_per_id" msprop:Generator_ColumnPropNameInTable="loc_per_idColumn" msprop:Generator_UserColumnName="loc_per_id" type="xs:int" minOccurs="0" />
              <xs:element name="loc_fre_id" msprop:Generator_ColumnVarNameInTable="columnloc_fre_id" msprop:Generator_ColumnPropNameInRow="loc_fre_id" msprop:Generator_ColumnPropNameInTable="loc_fre_idColumn" msprop:Generator_UserColumnName="loc_fre_id" type="xs:int" minOccurs="0" />
              <xs:element name="loc_id_usuario" msprop:Generator_ColumnVarNameInTable="columnloc_id_usuario" msprop:Generator_ColumnPropNameInRow="loc_id_usuario" msprop:Generator_ColumnPropNameInTable="loc_id_usuarioColumn" msprop:Generator_UserColumnName="loc_id_usuario" type="xs:int" minOccurs="0" />
              <xs:element name="loc_id_orden" msprop:Generator_ColumnVarNameInTable="columnloc_id_orden" msprop:Generator_ColumnPropNameInRow="loc_id_orden" msprop:Generator_ColumnPropNameInTable="loc_id_ordenColumn" msprop:Generator_UserColumnName="loc_id_orden" type="xs:int" minOccurs="0" />
              <xs:element name="loc_id_cod1" msprop:Generator_ColumnVarNameInTable="columnloc_id_cod1" msprop:Generator_ColumnPropNameInRow="loc_id_cod1" msprop:Generator_ColumnPropNameInTable="loc_id_cod1Column" msprop:Generator_UserColumnName="loc_id_cod1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_id_cod2" msprop:Generator_ColumnVarNameInTable="columnloc_id_cod2" msprop:Generator_ColumnPropNameInRow="loc_id_cod2" msprop:Generator_ColumnPropNameInTable="loc_id_cod2Column" msprop:Generator_UserColumnName="loc_id_cod2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_id_cod3" msprop:Generator_ColumnVarNameInTable="columnloc_id_cod3" msprop:Generator_ColumnPropNameInRow="loc_id_cod3" msprop:Generator_ColumnPropNameInTable="loc_id_cod3Column" msprop:Generator_UserColumnName="loc_id_cod3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_id_cod4" msprop:Generator_ColumnVarNameInTable="columnloc_id_cod4" msprop:Generator_ColumnPropNameInRow="loc_id_cod4" msprop:Generator_ColumnPropNameInTable="loc_id_cod4Column" msprop:Generator_UserColumnName="loc_id_cod4" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="frecuencia" msprop:Generator_ColumnVarNameInTable="columnfrecuencia" msprop:Generator_ColumnPropNameInRow="frecuencia" msprop:Generator_ColumnPropNameInTable="frecuenciaColumn" msprop:Generator_UserColumnName="frecuencia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loc_cupo" msprop:Generator_ColumnVarNameInTable="columnloc_cupo" msprop:Generator_ColumnPropNameInRow="loc_cupo" msprop:Generator_ColumnPropNameInTable="loc_cupoColumn" msprop:Generator_UserColumnName="loc_cupo" type="xs:double" minOccurs="0" />
              <xs:element name="loc_plazo" msprop:Generator_ColumnVarNameInTable="columnloc_plazo" msprop:Generator_ColumnPropNameInRow="loc_plazo" msprop:Generator_ColumnPropNameInTable="loc_plazoColumn" msprop:Generator_UserColumnName="loc_plazo" type="xs:int" minOccurs="0" />
              <xs:element name="lst_id" msprop:Generator_ColumnVarNameInTable="columnlst_id" msprop:Generator_ColumnPropNameInRow="lst_id" msprop:Generator_ColumnPropNameInTable="lst_idColumn" msprop:Generator_UserColumnName="lst_id" type="xs:int" />
              <xs:element name="loc_nuevo" msprop:Generator_ColumnVarNameInTable="columnloc_nuevo" msprop:Generator_ColumnPropNameInRow="loc_nuevo" msprop:Generator_ColumnPropNameInTable="loc_nuevoColumn" msprop:Generator_UserColumnName="loc_nuevo" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:RUT_LOCAL" />
      <xs:field xpath="mstns:loc_id" />
    </xs:unique>
  </xs:element>
</xs:schema>